CalendarPeriod

Entity Definition

Logical Name : CalendarPeriod
Physical Name : CA_CLD_PRD

A period of time in a particular Calendar, defined by a start & end date & time stamp.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CalendarID (FK)(PK) A unique system assigned identifier for the Calendar. ID_CLD Identity integer CalendarLevel(CA_CLD_LV)
CalendarLevelID (FK)(PK) A unique system assigned identifier for the CalendarLevel. ID_CLD_LV Identity integer CalendarLevel(CA_CLD_LV)
CalendarPeriodID (PK) A unique system assigned identifier for this CalendarPeriod ID_CLD_PRD Identity integer
StartDateTime The date and time the CalendarPeriod begins TS_SRT AuditDateTime datetime
EndDateTime The date and time the CalendarPeriod ends. TS_END AuditDateTime datetime
CalendarPeriodName The name assigned to this calendar period for reporting and presentation purposes. NM_CLD_PRD Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
CalendarLevel defines CalendarPeriod
CalendarPeriod is child AssociatedCalendarPeriod
CalendarPeriod may trigger CalendarPeriodRewardDerivationRuleEligibility
CalendarPeriod is parent AssociatedCalendarPeriod
CalendarPeriod is the start of ReportingPeriod
CalendarPeriod designated period of BusinessUnitGroupSchedule
CalendarPeriod is the end of ReportingPeriod

Logical Views containing CalendarPeriod

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 02400 - Control Transaction Macro View
Logical 02430 - Control Transaction - Period Open Close View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference
Logical 06100 - Calendar View
Logical 11160 - Worker - Reporting View